Merge Datatable

Command Prototype

dtTable = Datatable.MergeDataTable(dtLeftTable,dtRightTable,strHow,strLeftKey,strRightKey,bSort)

Command Description

Sort the specified column of a datatable

Parameter Description

Required Parameter

dtLeftTable--Datatable 1 to be merged

dtRightTable--Datatable 2 to be merged

strHow--The method to join two tables

strLeftKey--Column name of the left table to use as the basis for joining

strRightKey--Column name of the right table to use as the basis for joining

bSort--When set as True, the merged table will be sorted by the values of a given column (ie, the values of a specified column like left_on) before it is output

return

dtTable--The variable used to save the output of the function call